package com.ucvisitorsapp.dao;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import com.ucvisitorsapp.dto.Building;

public class BuildingSQLiteStub extends SQLiteOpenHelper implements IBuildingSQLite {

	private static final String DATABASE_NAME = "buildingDB";
	private static final String BUILDING_TABLE_NAME = "building";
	private static final String BUILDING_COLUMN_HEADING = "Building Name";
	private static final String LOCATION_COLUMN_HEADING = "Location";
	private static final String BUILDING_TABLE_CREATE = "CREATE TABLE" + BUILDING_TABLE_NAME + " (" +
			BUILDING_COLUMN_HEADING + " TEXT, " + LOCATION_COLUMN_HEADING + " TEXT);";
	
	BuildingSQLiteStub(Context context){
		super(context, DATABASE_NAME, null, 1);
	}
	
	public void onCreate(SQLiteDatabase db, Context context) {
		
		db.execSQL(BUILDING_TABLE_CREATE);
	}

	@Override
	public void addRow(Building building, SQLiteDatabase db) throws Exception {
		// TODO Auto-generated method stub
		
	}

	@Override
	public Building getRow(int index, SQLiteDatabase db) throws Exception {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
		// TODO Auto-generated method stub
		
	}

	@Override
	public void onCreate(SQLiteDatabase arg0) {
		// TODO Auto-generated method stub
		
	}

	@Override
	public SQLiteDatabase openOrCreateDatabase() {
		// TODO Auto-generated method stub
		return null;
	}


}
